Tabela Invoice

Definicja tabeli Invoice

Name

Invoice

Code

Invoice

Comment

PL: Definicja zasad fakturowania
EN: Corporate invoice rules definition
DE: Die Tabelle fur die Herrschaft der Faktur


Lista kolumn tabeli Invoice

Name

Code

InvoiceID

InvoiceID

PaymentTypeID

PaymentTypeID

PaymentPeriodID

PaymentPeriodID

PaymentTermID

PaymentTermID

FirstPeriodPaymentID

FirstPeriodPaymentID

InvoiceChangeRuleID

InvoiceChangeRuleID

ContractID

ContractID

InvoiceProductionID

InvoiceProductionID

InvoicingKindID

InvoicingKindID

InvoiceNo

InvoiceNo

Notes

Notes

PaymentPeriodFromID

PaymentPeriodFromID

AutomaticInvoice

AutomaticInvoice

SendInvoiceToClient

SendInvoiceToClient

PaymentPeriodTo

PaymentPeriodTo

InvoiceAttachments

InvoiceAttachments

Active

Active

PaymentDays

PaymentDays


Kolumna InvoiceID tabeli Invoice

Definicja kolumny InvoiceID tabeli Invoice

Name

InvoiceID

Code

InvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PaymentTypeID tabeli Invoice

Definicja kolumny PaymentTypeID tabeli Invoice

Name

PaymentTypeID

Code

PaymentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentPeriodID tabeli Invoice

Definicja kolumny PaymentPeriodID tabeli Invoice

Name

PaymentPeriodID

Code

PaymentPeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PaymentTermID tabeli Invoice

Definicja kolumny PaymentTermID tabeli Invoice

Name

PaymentTermID

Code

PaymentTermID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FirstPeriodPaymentID tabeli Invoice

Definicja kolumny FirstPeriodPaymentID tabeli Invoice

Name

FirstPeriodPaymentID

Code

FirstPeriodPaymentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoiceChangeRuleID tabeli Invoice

Definicja kolumny InvoiceChangeRuleID tabeli Invoice

Name

InvoiceChangeRuleID

Code

InvoiceChangeRuleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractID tabeli Invoice

Definicja kolumny ContractID tabeli Invoice

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InvoiceProductionID tabeli Invoice

Definicja kolumny InvoiceProductionID tabeli Invoice

Name

InvoiceProductionID

Code

InvoiceProductionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InvoicingKindID tabeli Invoice

Definicja kolumny InvoicingKindID tabeli Invoice

Name

InvoicingKindID

Code

InvoicingKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID rodzaju fakturowania dla faktur ryczaltowych


Kolumna InvoiceNo tabeli Invoice

Definicja kolumny InvoiceNo tabeli Invoice

Name

InvoiceNo

Code

InvoiceNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Notes tabeli Invoice

Definicja kolumny Notes tabeli Invoice

Name

Notes

Code

Notes

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna PaymentPeriodFromID tabeli Invoice

Definicja kolumny PaymentPeriodFromID tabeli Invoice

Name

PaymentPeriodFromID

Code

PaymentPeriodFromID

Data Type

DATE

Mandatory

No

Comment

 


Kolumna AutomaticInvoice tabeli Invoice

Definicja kolumny AutomaticInvoice tabeli Invoice

Name

AutomaticInvoice

Code

AutomaticInvoice

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna SendInvoiceToClient tabeli Invoice

Definicja kolumny SendInvoiceToClient tabeli Invoice

Name

SendInvoiceToClient

Code

SendInvoiceToClient

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PaymentPeriodTo tabeli Invoice

Definicja kolumny PaymentPeriodTo tabeli Invoice

Name

PaymentPeriodTo

Code

PaymentPeriodTo

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InvoiceAttachments tabeli Invoice

Definicja kolumny InvoiceAttachments tabeli Invoice

Name

InvoiceAttachments

Code

InvoiceAttachments

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna Active tabeli Invoice

Definicja kolumny Active tabeli Invoice

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Aktywnosc sposobu fakturowania


Kolumna PaymentDays tabeli Invoice

Definicja kolumny PaymentDays tabeli Invoice

Name

PaymentDays

Code

PaymentDays

Data Type

NUMBER(10)

Mandatory

No

Comment

Pole dotyczy terminu platnosci dla zasad fakturowania i przechowuje ilosc dni
po jakich nalezy dokonac wplaty


Lista kluczy tabeli Invoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Invoice

Definicja klucza Identifier_1 tabeli Invoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment